package com.hue.springbooteasyexcel.domain;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import lombok.Data;

import java.util.Date;

/**
 * @author 姚凤桥
 * @Date 2022/1/17 15:59
 * @Description: 线损分析的excelVo
 */
@Data
public class LineLossAnalyzeExcelVo {
    private Long id;

    /**
     * 供电单位
     */
    @ExcelProperty(value = "供电单位", index = 0)
    private String powerSupply;
    /**
     * 台区名称
     */
    @ExcelProperty(value = "台区名称", index = 1)
    private String courtsName;
    /**
     * 台区编号
     */
    @ExcelProperty(value = "台区编号", index = 2)
    private String courtsSn;
    /**
     * 终端地址
     */
    @ExcelProperty(value = "终端地址", index = 3)
    private String terminalAddress;
    /**
     * 电能表总数
     */
    @ExcelProperty(value = "电能表总数", index = 4)
    private String electricityCount;
    /**
     * 台区容量(KVA)
     */
    @ExcelProperty(value = "台区容量(KVA)", index = 5)
    private Integer courtsCapacity;
    /**
     * 数据时间
     */
    @ExcelProperty(value = "数据时间", index = 6)
    @DateTimeFormat(value = "yyyyMMdd")
    private Date dataTime;
    /**
     * 日分析-供电量(kWh)
     */
    @ExcelProperty(value = "日分析-供电量(kWh)", index = 8)
    private String powerSupplyDay;
    /**
     * 日分析-用电量(kWh)
     */
    @ExcelProperty(value = "日分析-用电量(kWh)", index = 9)
    private String powerUseDay;
    /**
     * 日分析-供电量(kWh)
     */
    @ExcelProperty(value = "日分析-供电量(kWh)", index = 10)
    private String powerLossDay;
    /**
     * 日分析-线损率(%)
     */
    @ExcelProperty(value = "日分析-线损率(%)", index = 11)
    private String lineLossRateDay;
    /**
     * 日分析-线损类型
     */
    @ExcelProperty(value = "日分析-线损类型", index = 12)
    private String lineLossTypeDay;
    /**
     * A相-供电量(kWh)
     */
    @ExcelProperty(value = "A相-供电量(kWh)", index = 13)
    private String powerSupplyA;
    /**
     * A相-用电量(kWh)
     */
    @ExcelProperty(value = "A相-用电量(kWh)", index = 14)
    private String powerUseA;
    /**
     * A相-供电量(kWh)
     */
    @ExcelProperty(value = "A相-供电量(kWh)", index = 15)
    private String powerLossA;
    /**
     * A相-线损率(%)
     */
    @ExcelProperty(value = "A相-线损率(%)", index = 16)
    private String lineLossRateA;
    /**
     * A相-线损类型
     */
    @ExcelProperty(value = "A相-线损类型", index = 17)
    private String lineLossTypeA;
    /**
     * B相-供电量(kWh)
     */
    @ExcelProperty(value = "B相-供电量(kWh)", index = 18)
    private String powerSupplyB;
    /**
     * B相-用电量(kWh)
     */
    @ExcelProperty(value = "B相-用电量(kWh)", index = 19)
    private String powerUseB;
    /**
     * B相-供电量(kWh)
     */
    @ExcelProperty(value = "B相-供电量(kWh)", index = 20)
    private String powerLossB;
    /**
     * B相-线损率(%)
     */
    @ExcelProperty(value = "B相-线损率(%)", index = 21)
    private String lineLossRateB;
    /**
     * B相-线损类型
     */
    @ExcelProperty(value = "B相-线损类型", index = 22)
    private String lineLossTypeB;
    /**
     * C相-供电量(kWh)
     */
    @ExcelProperty(value = "C相-供电量(kWh)", index = 23)
    private String powerSupplyC;
    /**
     * C相-用电量(kWh)
     */
    @ExcelProperty(value = "C相-用电量(kWh)", index = 24)
    private String powerUseC;
    /**
     * C相-供电量(kWh)
     */
    @ExcelProperty(value = "C相-供电量(kWh)", index = 25)
    private String powerLossC;
    /**
     * C相-线损率(%)
     */
    @ExcelProperty(value = "C相-线损率(%)", index = 26)
    private String lineLossRateC;
    /**
     * C相-线损类型
     */
    @ExcelProperty(value = "C相-线损类型", index = 27)
    private String lineLossTypeC;
    /**
     * 采集覆盖率(%)
     */
    @ExcelProperty(value = "采集覆盖率(%)", index = 28)
    private Double gatherCoverRate;
    /**
     * 采集成功率(%)
     */
    @ExcelProperty(value = "采集成功率(%)", index = 29)
    private Double gatherSuccessRate;
    /**
     * 相位关系识别成功率(%)
     */
    @ExcelProperty(value = "相位关系识别成功率(%)", index = 30)
    private Double phaseRelationSuccessRate;
    /**
     * 是否可参与分相线损计算
     */
    @ExcelProperty(value = "是否可参与分相线损计算", index = 31)
    private String isJoinLineLossCalculate;
    /**
     * 是否存在修正相位
     */
    @ExcelProperty(value = "是否存在修正相位", index = 32)
    private String isExistPhaseUpdate;
    /**
     * 是否HPLC台区
     */
    @ExcelProperty(value = "是否HPLC台区", index = 33)
    private String isHplcCourts;
    /**
     * 是否含光伏用户
     */
    @ExcelProperty(value = "是否含光伏用户", index = 34)
    private String isContainPhotovoltaicUser;
    /**
     * 回算状态
     */
    @ExcelProperty(value = "回算状态", index = 35)
    private String backStatus;
    /**
     * 台区经理工号
     */
    @ExcelProperty(value = "台区经理工号", index = 36)
    private String courtsManagerSn;
    /**
     * 台区经理姓名
     */
    @ExcelProperty(value = "台区经理姓名", index = 37)
    private String courtsManagerName;
    /**
     * 投运日期
     */
    @ExcelProperty(value = "投运日期", index = 38)
    private Date castTime;
    /**
     * PMS中投运日期
     */
    @ExcelProperty(value = "PMS中投运日期", index = 39)
    @DateTimeFormat(value = "yyyyMMdd")
    private Date pmsTime;
}
